吳老師教學部落格 - 網紅的藏寶箱

吳老師教學部落格

04 VBA插入空白列與刪除空白列

東吳EXCEL VBA與資料庫雲端設計116第6次上課內容： 01_重點回顧與格式化日期 02_用VBA設計格式化日期迴圈與邏輯判斷 03_VBA還原格式與插入空白列 04_VBA插入空白列與刪除...

2021-08-09 22:54:48 有 313 人看過有 7 人說讚

05 VBA向上追蹤與WORD表格讀取到EXCEL

東吳EXCEL VBA與資料庫雲端設計116第6次上課內容： 01_重點回顧與格式化日期 02_用VBA設計格式化日期迴圈與邏輯判斷 03_VBA還原格式與插入空白列 04_VBA插入空白列與刪除...

2021-08-09 22:53:25 有 236 人看過有 3 人說讚

02 用VBA設計格式化日期迴圈與邏輯判斷

東吳EXCEL VBA與資料庫雲端設計116第6次上課內容： 01_重點回顧與格式化日期 02_用VBA設計格式化日期迴圈與邏輯判斷 03_VBA還原格式與插入空白列 04_VBA插入空白列與刪除...

2021-08-09 22:52:52 有 120 人看過有 0 人說讚

01 重點回顧與格式化日期

東吳EXCEL VBA與資料庫雲端設計116第6次上課內容： 01_重點回顧與格式化日期 02_用VBA設計格式化日期迴圈與邏輯判斷 03_VBA還原格式與插入空白列 04_VBA插入空白列與刪除...

2021-08-09 22:52:16 有 53 人看過有 1 人說讚

07 黑名單改為VBA篩選與複製範圍

東吳EXCEL VBA與資料庫雲端設計116第6次上課內容： 01_重點回顧與格式化日期 02_用VBA設計格式化日期迴圈與邏輯判斷 03_VBA還原格式與插入空白列 04_VBA插入空白列與刪除...

2021-08-09 22:51:40 有 155 人看過有 4 人說讚

06 黑名單定義名稱與COUNTIF比對資料與篩選

東吳EXCEL VBA與資料庫雲端設計116第6次上課內容： 01_重點回顧與格式化日期 02_用VBA設計格式化日期迴圈與邏輯判斷 03_VBA還原格式與插入空白列 04_VBA插入空白列與刪除...

2021-08-09 22:51:10 有 58 人看過有 1 人說讚

03 VBA還原格式與插入空白列

東吳EXCEL VBA與資料庫雲端設計116第6次上課內容： 01_重點回顧與格式化日期 02_用VBA設計格式化日期迴圈與邏輯判斷 03_VBA還原格式與插入空白列 04_VBA插入空白列與刪除...

2021-08-09 22:47:53 有 55 人看過有 1 人說讚

05 存檔與邏輯判斷

TQC+Python基礎程式語言應用班第1次上課(環境設定與基本語法) 01_問卷結果與懶人包 02_課程內容說明 03_建置Python開發環境與spyder設定 04_變數型態與轉型說明 05_...

2021-08-03 22:55:13 有 680 人看過有 5 人說讚

04 變數型態與轉型說明

TQC+Python基礎程式語言應用班第1次上課(環境設定與基本語法) 01_問卷結果與懶人包 02_課程內容說明 03_建置Python開發環境與spyder設定 04_變數型態與轉型說明 05_...

2021-08-03 22:54:45 有 143 人看過有 0 人說讚

06 邏輯判斷改為多重邏輯

TQC+Python基礎程式語言應用班第1次上課(環境設定與基本語法) 01_問卷結果與懶人包 02_課程內容說明 03_建置Python開發環境與spyder設定 04_變數型態與轉型說明 05_...

2021-08-03 22:54:32 有 151 人看過有 2 人說讚

A PHP Error was encountered

Severity: Notice

Message: Undefined variable: keyword

Filename: views/author_post_list_yt.php

Line Number: 107

Backtrace:

File: /var/www/html/KOL/kolauthor/application/views/author_post_list_yt.php
Line: 107
Function: _error_handler

File: /var/www/html/KOL/kolauthor/application/controllers/Author.php
Line: 75
Function: view

File: /var/www/html/KOL/kolauthor/application/controllers/Author.php
Line: 21
Function: author_article

File: /var/www/html/KOL/kolauthor/public/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Notice

Message: Undefined variable: keyword_tree

Filename: views/author_post_list_yt.php

Line Number: 107

Backtrace:

File: /var/www/html/KOL/kolauthor/application/views/author_post_list_yt.php
Line: 107
Function: _error_handler

File: /var/www/html/KOL/kolauthor/application/controllers/Author.php
Line: 75
Function: view

File: /var/www/html/KOL/kolauthor/application/controllers/Author.php
Line: 21
Function: author_article

File: /var/www/html/KOL/kolauthor/public/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Notice

Message: Trying to access array offset on value of type null

Filename: views/author_post_list_yt.php

Line Number: 107

Backtrace:

File: /var/www/html/KOL/kolauthor/application/views/author_post_list_yt.php
Line: 107
Function: _error_handler

File: /var/www/html/KOL/kolauthor/application/controllers/Author.php
Line: 75
Function: view

File: /var/www/html/KOL/kolauthor/application/controllers/Author.php
Line: 21
Function: author_article

File: /var/www/html/KOL/kolauthor/public/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Notice

Message: Trying to access array offset on value of type null

Filename: views/author_post_list_yt.php

Line Number: 107

Backtrace:

File: /var/www/html/KOL/kolauthor/application/views/author_post_list_yt.php
Line: 107
Function: _error_handler

File: /var/www/html/KOL/kolauthor/application/controllers/Author.php
Line: 75
Function: view

File: /var/www/html/KOL/kolauthor/application/controllers/Author.php
Line: 21
Function: author_article

File: /var/www/html/KOL/kolauthor/public/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: Invalid argument supplied for foreach()

Filename: views/author_post_list_yt.php

Line Number: 107

Backtrace:

File: /var/www/html/KOL/kolauthor/application/views/author_post_list_yt.php
Line: 107
Function: _error_handler

File: /var/www/html/KOL/kolauthor/application/controllers/Author.php
Line: 75
Function: view

File: /var/www/html/KOL/kolauthor/application/controllers/Author.php
Line: 21
Function: author_article

File: /var/www/html/KOL/kolauthor/public/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Notice

Message: Undefined variable: keyword

Filename: views/author_post_list_yt.php

Line Number: 112

Backtrace:

File: /var/www/html/KOL/kolauthor/application/views/author_post_list_yt.php
Line: 112
Function: _error_handler

File: /var/www/html/KOL/kolauthor/application/controllers/Author.php
Line: 75
Function: view

File: /var/www/html/KOL/kolauthor/application/controllers/Author.php
Line: 21
Function: author_article

File: /var/www/html/KOL/kolauthor/public/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Notice

Message: Undefined variable: main_keyword

Filename: views/author_post_list_yt.php

Line Number: 112

Backtrace:

File: /var/www/html/KOL/kolauthor/application/views/author_post_list_yt.php
Line: 112
Function: _error_handler

File: /var/www/html/KOL/kolauthor/application/controllers/Author.php
Line: 75
Function: view

File: /var/www/html/KOL/kolauthor/application/controllers/Author.php
Line: 21
Function: author_article

File: /var/www/html/KOL/kolauthor/public/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Notice

Message: Undefined variable: main_keyword

Filename: views/author_post_list_yt.php

Line Number: 124

Backtrace:

File: /var/www/html/KOL/kolauthor/application/views/author_post_list_yt.php
Line: 124
Function: _error_handler

File: /var/www/html/KOL/kolauthor/application/controllers/Author.php
Line: 75
Function: view

File: /var/www/html/KOL/kolauthor/application/controllers/Author.php
Line: 21
Function: author_article

File: /var/www/html/KOL/kolauthor/public/index.php
Line: 315
Function: require_once